Forum Discussion
sumwhen
Hallo together, I have an table which in the row are "EZ" or "DZ" and I like counting the EZ and DZ. with the formula for EZ: =SUMWHEN(K2:K92;"EZ";1;sum(K2:K92)). I got a warnung "too many argumenst...
In Excel ? there isn't a function called sumwhen, aren't you looking for countif ?
=countif(k2:k92, "EZ")